﻿using System;
using System.Collections.Generic;
using System.Text;

namespace DAO
{
    public class SqlString
    {
        #region//系统权限
        //查询所有的权限
        public static string selectAllBig_Class = "S_selectAllBig_Class";
        //查询所有的功能
        public static string SelectAllSmall_Class = "S_SelectAllSmall_Class";
        #endregion

        #region//管理员权限等功能
        //管理员登录登录
        public static string selectOneAdminByName = "S_selectOneAdminByName";

        /// <summary>
        /// 查询所有后台用户信息
        /// </summary>
        public static string selectAllV_admin = "S_selectAllV_admin";

        /// <summary>
        /// 系统共用的查询过程没有条件
        /// </summary>
        public static string SP_select = "SP_select";

        /// <summary>
        /// 系统共用的删除过程
        /// </summary>
        public static string SP_delete = "SP_delete";

        /// <summary>
        /// 用来执行Sql语句的方法
        /// </summary>
        public static string SP_sqlStr = "SP_sqlStr";

        /// <summary>
        /// 根据条件查询
        /// </summary>
        public static string S_selectOne = "S_selectOne";

        /// <summary>
        /// 查询所有的权限类型信息
        /// </summary>
        public static string S_selectAllAdminLevel = "S_selectAllAdminLevel";

        /// <summary>
        /// 系统共用的查询固定列数的方法
        /// </summary>
        public static string S_selectNumber = "S_selectNumber";
        #endregion

        #region//会员中心存储过程     孙艳军
        /// <summary>
        /// 查询所有用户的信息
        /// </summary>
        public static string selectAllUserInFo = "S_selectAllUserInFo";

        /// <summary>
        /// 根据一个用户的ID查询出所有的用户信息信息
        /// </summary>
        public static string selectAllV_UserInFoByUID = "S_selectAllV_UserInFoByUID";

        /// <summary>
        /// 根据UserId唯一标识来清空用户的密码
        /// </summary>
        public static string updateOneUserPWD_clearByUID = "S_updateOneUserPWD_clearByUID";

        /// <summary>
        /// 根据用户ID为用户修改余额
        /// </summary>
        public static string updateOneUserUBalanceByUID = "S_updateOneUserUBalanceByUID";

        /// <summary>
        /// 查询在一个时间段内所有的用户
        /// </summary>
        public static string selectAllV_UserInFoByAddTime = "S_selectAllV_UserInFoByAddTime";

        /// <summary>
        /// 根据用户名查询所有用户的信息
        /// </summary>
        public static string electAllV_UserInFoByLikeName = "S_selectAllV_UserInFoByLikeName";

        /// <summary>
        /// 根据用户ID删除用户的信息和所有留言
        /// </summary>
        public static string deleteOneUseradnDeleteLeaveMessageAllByUID = "S_deleteOneUseradnDeleteLeaveMessageAllByUID";

        /// <summary>
        /// 查询所有的用户留言信息
        /// </summary>
        public static string selectAllV_LeaveMessageInFo = "S_selectAllV_LeaveMessageInFo";

        /// <summary>
        /// 根据ID删除一个用户留言信息
        /// </summary>
        public static string deleteOneLeaveMessageByLMID = "S_deleteOneLeaveMessageByLMID";

        /// <summary>
        /// 修改留言状态
        /// </summary>
        public static string updateLeaveMessageByLMID = "S_updateLeaveMessageByLMID";

        /// <summary>
        /// 根据留言的时间来查询用户的留言信息
        /// </summary>
        public static string selectAllLeaveMessageByEndTimeadnStatTiem = "S_selectAllLeaveMessageByEndTimeadnStatTiem";

        /// <summary>
        /// 根据用户名查询所有留言信息
        /// </summary>
        public static string selectAllLeaveMessageBylikeUName = "S_selectAllLeaveMessageBylikeUName";

        /// <summary>
        /// 根据ID查询留言信息
        /// </summary>
        public static string selectOneLeaveMessageByLMID = "S_selectOneLeaveMessageByLMID";

        /// <summary>
        /// 设定级别对应的余额,从新设置后uesr的级别自动更改
        /// </summary>
        public static string updateOneGradeLevelandUpdateUserUBalance = "S_updateOneGradeLevelandUpdateUserUBalance";

        /// <summary>
        /// 显示所有GradeLevel表信息
        /// </summary>
        public static string selectAllGradeLevel = "S_selectAllGradeLevel";

        /// <summary>
        /// 根据级别id来获取 级别名称和级别对应的余额
        /// </summary>
        public static string selectOneGradeLevelByGLID = "S_selectOneGradeLevelByGLID";

        /// <summary>
        /// 修改级别表的某一行
        /// </summary>
        public static string updateOneGradeLevelByID = "S_updateOneGradeLevelByID";

        /// <summary>
        /// 初始化显示所有UserGrade表信息（不需分页）
        /// </summary>
        public static string selectAllUserGrade = "S_selectAllUserGrade";

        /// <summary>
        /// 根据Id查询一个等级信息
        /// </summary>
        public static string selectOneUserGradeByUGID = "S_selectOneUserGradeByUGID";

        /// <summary>
        /// 修改某一UserGrade的某一行信息
        /// </summary>
        public static string updateOneUserGradeByUGID = "S_updateOneUserGradeByUGID";

        #endregion

        #region//会员中心存储过程    贺丹卉
        /// <summary>
        /// 修改一个会员信息
        /// </summary>
        public static string updateUserInFoByUID = "S_updateUserInFoByUID";

        /// <summary>
        /// 根据用户名和密码查询相应用户看是否可以登录
        /// </summary>
        public static string selectOneUserByUserNameandUserPwd = "S_selectOneUserByUserNameandUserPwd";

        /// <summary>
        /// 注册新用户
        /// </summary>
        public static string insertOneUserInFo = "S_insertOneUserInFo";

        /// <summary>
        /// 根据会员ID查询会员订单
        /// </summary>
        public static string selectOneV_OrderFormByUID = "S_selectOneV_OrderFormByUID";

        /// <summary>
        /// 根据用户ID修改用户的密码
        /// </summary>
        public static string updateOneUserPwdByUID = "S_updateOneUserPwdByUID";

        /// <summary>
        /// 添加一个留言信息
        /// </summary>
        public static string insertOneLeaveMessageInFo = "S_insertOneLeaveMessageInFo";

        /// <summary>
        /// 查看用户名是否已存在
        /// </summary>
        public static string selectCheckUserNameisINUser = "S_selectCheckUserNameisINUser";

        /// <summary>
        /// 查看用户邮箱是否存在
        /// </summary>
        public static string selectCheckUserUEmailisINUser = "S_selectCheckUserUEmailisINUser";




        #endregion

    }
}
